How to: Add tables or queries to a query.
Solution:
Go to the Query Design view, and use the 'Show Table...' command under the 'Query' menu.
1) If the Database window is not active, activate the Database window.
2) Go to the Query Design view.
3) Select the 'Query' menu and select 'Show Table...'. (The Show Table dialog box appears.)
4) Do one of the following:
Click the tab
a) Click the 'Tables' tab to display a list of all the tables in the database.
b) Click the 'Queries' tab to display a list of all the queries in the database.
c) Click the 'Both' tab to display a list of all the tables AND queries in the database.
5) Select the table or tables to add to the query from the list box.
NOTE: To select more than one adjacent table, press and hold down SHIFT while selecting the tables. To select more than one non-adjacent table, press and hold down CTRL while selecting the tables.
6) Click 'Add'. (The table(s) appears in the Query Design window.)
7) Click 'Close' when finished adding tables.
8) Select the 'File' menu and select 'Save' to save the design changes.
9) (Optional) Select the 'File' menu and select 'Close' to close the Query Design view.
